If you are installing iMIS Analytics in a two-tier configuration (see Installing Analytics for details), you must create a linked server definition for the iMIS host to enable iMIS Analytics to connect to your iMIS database. This linked server definition must be created on the iMIS Analytics host. There are many ways to specify the login security credentials for the remote server when creating a linked server definition. This procedure describes the least restrictive method for specifying the security credentials for the remote server. You can adapt this procedure as necessary if you need more stringent control over security.
Before you begin
Note: If you are unsure whether your installations of SQL Server 2000 and Analysis Services are at the required service pack level, see Determining the service pack level for SQL Server and Analysis Services.
To create a linked server definition for two-tier configurations
The Enterprise Manager window appears.
The details pane displays the linked servers defined on the local default instance of SQL Server on the iMIS Analytics host.
The Linked Server Properties dialog appears.
The new linked server definition appears under the Linked Servers node in the Enterprise Manager tree pane.
The details pane displays the support services for the local default instance of SQL Server on the iMIS Analytics host.
Note: When you are using a linked server definition to enable iMIS Analytics to connect to the iMIS database on the remote iMIS host, the Distributed Transaction Coordinator service must be running on the local default instance of SQL Server on the iMIS Analytics host to enable iMIS Analytics to extract data from the remote iMIS database.
10.6 Production Release. Updated 9/28/2005 4:09:52 PM
© Copyright by Advanced Solutions International, Inc.
All rights reserved.